Appendix F: Oracle database creation script

If your account on the Meridian Enterprise Server server does not have sufficient privileges to create a new database on the database server as described in Creating a Meridian Explorer repository, you can create the repository database with the following script.

To create a repository database on the database server:

1. In SQLPlus, run the following PL-SQL script to create an empty database. Change every occurrence of <UserName> and <Password> to the desired user name and password respectively.

Oracle script

CREATE USER <SchemaName> IDENTIFIED BY MANAGER ACCOUNT UNLOCK DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE "DEFAULT";
ALTER USER <SchemaName> QUOTA 100M ON USERS;
GRANT RESOURCE, CREATE SESSION TO <SchemaName>; 
GRANT RESOURCE, CONNECT TO <SchemaName>;
GRANT EXECUTE ON CTX_DDL TO <SchemaName>;
GRANT EXECUTE ON "CTXSYS"."CTX_DDL" TO "<SchemaName>";
GRANT CREATE VIEW TO <SchemaName>;
GRANT CREATE UNLIMITED TABLESPACE TO <SchemaName>;
GRANT ALTER ANY TABLE TO <SchemaName>; 
GRANT CREATE PROCEDURE TO <SchemaName>;
GRANT CREATE TRIGGER TO <SchemaName>;